
<%@page import="classes.Reports"%>
<%@page import="java.util.ArrayList"%>
        <table id="table-1">
	<thead>
                <th>First Name</th>
                <th>Last Name</th>
                <th>Email</th>
		<th>Address</th>
	</thead>
	<tbody>
	<%
         
            String query="SELECT P.LastName, P.FirstName, C.Email, P.Address"+
                    " FROM brchung.client C, brchung.person P"+
                    " WHERE C.Id = P.SSN"+
                    " Order by 	P.LastName;";
            Reports.getConnection(query);
            ArrayList<String[]> rs=Reports.getResults(1,2,3,4);
            for(int i=0;i<rs.size();i++){
                out.print("<tr>");
                for(int j=0;j<4;j++)
                    out.print("<td>"+rs.get(i)[j]+"</td>");
                out.print("</tr>");
            }
        %>
	</tbody>
    </table>
